* Clean up
clear all

/* Set working directory: please set your own
cd "~/Dropbox/JOP third submission/JOP replication/"
*/

* Open dataset
use 01_data/whole_spain.dta, clear


* 2014/5-2019
reghdfe pp_voteshare post##ep##ciutadella if period > 1 & menorca_not_ciutadella == 0, absorb(mesa_code_elecspecific) cluster(mesa_code_elecspecific)
est store twoperiods_menorca_notciuta

* Pre vs. post
reghdfe pp_voteshare post##ep##ciutadella if menorca_not_ciutadella == 0, absorb(mesa_code_elecspecific) cluster(mesa_code_elecspecific)
est store prepost_menorca_notciuta

* Fixed effects for each period
reghdfe pp_voteshare post##ep##ciutadella i.period if menorca_not_ciutadella == 0, absorb(mesa_code_elecspecific) cluster(mesa_code_elecspecific)
est store threeper_menorca_notciuta

* Make table
esttab twoperiods_menorca_notciuta prepost_menorca_notciuta threeper_menorca_notciuta using 03_tables/tabled5.tex, tex se replace mtitles ("2014-2019" "2009-2019" "2009-2019")  keep (1.post 1.post#1.ep 1.post#1.ciutadella 1.post#1.ep#1.ciutadella 2.period) coeflabels (1.post "2019 election" 1.post#1.ep "EP election in 2019" 1.post#1.ciutadella "Ciutadella in 2019" 1.post#1.ep#1.ciutadella "EP 2019 x Ciutadella" 2.period "2014-2015 election") star(* 0.10 ** 0.05 *** 0.01) addnotes("All models include voting station * election type fixed effects" "Standard errors are clustered by voting station * election type") 
